from utils import mysql_util
base_column = ' id, attendence_id, status, create_time, update_time '

def select_by_attendenceid(attendence_id):
    sql = 'select' + base_column + 'from sm_face_attendence where attendence_id = %s'
    res = mysql_util.find_one(sql, (attendence_id))
    return res

def update(args):
    sql = 'update sm_face_attendence set status = %s, update_time = %s where id = %s'
    res = mysql_util.update(sql, (args))
    return res